/*
 Navicat Premium Data Transfer

 Source Server         : zp
 Source Server Type    : MySQL
 Source Server Version : 100019
 Source Host           : 117.50.39.41:3306
 Source Schema         : spider

 Target Server Type    : MySQL
 Target Server Version : 100019
 File Encoding         : 65001

 Date: 23/06/2020 19:56:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for position_type_info_v2
-- ----------------------------
DROP TABLE IF EXISTS `position_type_info_v2`;
CREATE TABLE `position_type_info_v2` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `position_type_name` varchar(50) DEFAULT NULL COMMENT '职位分类名称',
  `position_type_code` varchar(50) DEFAULT NULL COMMENT '职位分类code',
  `position_num` int(11) DEFAULT NULL COMMENT '职位分类中职位数量',
  `company_id` int(11) DEFAULT NULL COMMENT '公司id',
  `company_jc` varchar(100) DEFAULT NULL COMMENT '公司简称',
  `company_code` varchar(255) DEFAULT '',
  `status` char(5) NOT NULL DEFAULT '0' COMMENT '抓取状态',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '插入日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1001818 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of position_type_info_v2
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
